<?php

/**
 * Adds the default plugins
 *
 */
class Db_017_bbce_add_default_plugin_types extends Ot_Migrate_Migration_Abstract
{
    public function up($dba)
    {
        $query = "INSERT INTO `" . $this->tablePrefix . "tbl_slidestream_plugin` (`pluginName`, `status`) VALUES ('Marquee', 'enabled');";
        $dba->query($query);

        $query = "INSERT INTO `" . $this->tablePrefix . "tbl_slidetype` (`slidetype`, `status`) VALUES
                    ('Flickr', 'enabled'),
                    ('FLV', 'enabled'),
                    ('Image', 'enabled'),
                    ('Url', 'enabled'),
                    ('VisibleTweets', 'enabled'),
                    ('YouTube', 'enabled');";
        $dba->query($query);        
        
        $query = "INSERT INTO `" . $this->tablePrefix . "tbl_slide_plugin` (`pluginName`, `status`) VALUES
                    ('Impression', 'disabled'),
                    ('Schedule', 'enabled'),
                    ('Transition', 'disabled');";
        $dba->query($query);        
    }
    
    public function down($dba)
    {       
        $query = "";
        $dba->query($query);
    }
}